{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DataSheet","Hidden Data","Help"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"DataSheet","index":0,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Id","TrustId","SubmissionId","MetaSubmissionId","Research Ethics Committee Reference Number","Integrated Research Application System Number","Name of Trial","Target Number Of Patients Agreed?","Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)","Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)","Target Date To Recruit Patients Agreed?","Date Agreed to recruit target number of patients","Total Number Of Patients Recruited At The Agreed Target Date","Date That The Trial Closed To Recruitment","Reason For Closure Of Trial","Comments","AddedByUserId","AmendedByUserId","DateAdded","DateAmended",null,null,"Errors"]
[7097,1078,3698,38,"15/SC/0443",173722,"CAIN457A3302 - OPTIMISE STUDY","Number Agreed",5,5,"Please Select...",null,6,"2016-02-11","Recruitment Finished",null,"Unknown","Unknown","2016-04-25","2016-04-28",null,null,"Please indicate if Target Date Agreed to recruit patients is available "]

{"sheet":"Hidden Data","index":1,"n_rows":17,"n_cols":40,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SpreadsheetOne - Hidden Data"]
[]
[null,"******** PLEASE DO NOT CHANGE ANY OF THESE VALUES ********"]
[]
[null,"Hidden Data Key","Hidden Data Value",null,"XML",null,"Class"]
[null,"Is First Open","FALSE",null,"<?xml version=\"1.0\" encoding=\"utf-16\"?>\r\n<DataTableDataExportContainerOfNewPerfDeliveryDetail xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n\t<DataTypeName>Exbos.Applications.NHSRBVP.Components.BusinessObjects.NewPerfDeliveryDetail, Exbos.Applications.NHSRBVP.Components.BusinessObjects, Version=1.0.10.0, Culture=neutral, PublicKeyToken=null</DataTypeName>\r\n\t<Site Id=\"1\" AddressId=\"-1\" StatusId=\"51\" TypeId=\"401\" CultureId=\"1\" AddedByUserId=\"1\" AmendedByUserId=\"1\" DateAdded=\"2013-06-15T22:56:16\" DateAmended=\"2013-06-15T22:56:16\">\r\n\t\t<Name>CTP Submission Platform</Name>\r\n\t\t<Description/>\r\n\t</Site>\r\n\t<MetaSubmission Id=\"38\" StatusId=\"2001\" TypeId=\"2103\" SubmissionRangeStartDate=\"2015-04-01T00:00:00\" SubmissionRangeEndDate=\"2016-03-31T00:00:00\" SubmissionOpenDate=\"2016-04-01T00:00:00\" SubmissionWarningDate=\"2016-04-15T00:00:00\" SubmissionDeadlineDate=\"2016-04-29T00:00:00\" AddedByUserId=\"10\" AmendedByUserId=\"3\" DateAdded=\"2016-03-31T17:51:15\" DateAmended=\"2016-04-01T12:50:13\">\r\n\t\t<Name>Q4 15-16 PD</Name>\r\n\t</MetaSubmission>\r\n</DataTableDataExportContainerOfNewPerfDeliveryDetail>\r\n",null,"NewPerfDeliveryDetail"]
[null,"Development Mode","FALSE"]
[null,"Data Id",3698]
[null,"User Id",-1]
[null,"Data Id",40]
["<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>1</Order>\r\n\t<Name>Id</Name>\r\n\t<FriendlyName>Id</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>2</Order>\r\n\t<Name>TrustId</Name>\r\n\t<FriendlyName>TrustId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">1078</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>3</Order>\r\n\t<Name>SubmissionId</Name>\r\n\t<FriendlyName>SubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">3698</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>4</Order>\r\n\t<Name>MetaSubmissionId</Name>\r\n\t<FriendlyName>MetaSubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">38</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>5</Order>\r\n\t<Name>ReferenceNumber</Name>\r\n\t<FriendlyName>Research Ethics Committee Reference Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>6</Order>\r\n\t<Name>IntegratedResearchNumber</Name>\r\n\t<FriendlyName>Integrated Research Application System Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>20</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>7</Order>\r\n\t<Name>TrialName</Name>\r\n\t<FriendlyName>Name of Trial</FriendlyName>\r\n\t<UseTextArea>true</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>2000</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>8</Order>\r\n\t<Name>TargetTypeAgreedId</Name>\r\n\t<FriendlyName>Target Number Of Patients Agreed?</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2500</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2501</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Not Available / Not Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2502</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Number Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2503</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Range Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>9</Order>\r\n\t<Name>MinimumTargetValue</Name>\r\n\t<FriendlyName>Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>10</Order>\r\n\t<Name>MaximumTargetValue</Name>\r\n\t<FriendlyName>Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>11</Order>\r\n\t<Name>TargetDateAgreedTypeId</Name>\r\n\t<FriendlyName>Target Date To Recruit Patients Agreed?</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2600</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2601</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Not Available / Not Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2602</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Date Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>-99999911</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>12</Order>\r\n\t<Name>TargetDate</Name>\r\n\t<FriendlyName>Date Agreed to recruit target number of patients</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>13</Order>\r\n\t<Name>TotalPatientsRecruited</Name>\r\n\t<FriendlyName>Total Number Of Patients Recruited At The Agreed Target Date</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>14</Order>\r\n\t<Name>RecruitmentClosedDate</Name>\r\n\t<FriendlyName>Date That The Trial Closed To Recruitment</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>15</Order>\r\n\t<Name>ClosureReasonTypeId</Name>\r\n\t<FriendlyName>Reason For Closure Of Trial</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2700</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2701</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Recruitment Finished</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2702</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Withdrawn By Sponsor</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2703</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Withdrawn By Host</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>16</Order>\r\n\t<Name>Comments</Name>\r\n\t<FriendlyName>Comments</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>500</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>17</Order>\r\n\t<Name>AddedByUserId</Name>\r\n\t<FriendlyName>AddedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>329</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>18</Order>\r\n\t<Name>AmendedByUserId</Name>\r\n\t<FriendlyName>AmendedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>329</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>19</Order>\r\n\t<Name>DateAdded</Name>\r\n\t<FriendlyName>DateAdded</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2016-04-28T11:39:21.739625+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>20</Order>\r\n\t<Name>DateAmended</Name>\r\n\t<FriendlyName>DateAmended</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2016-04-28T11:39:21.739625+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>"]
["Id",null,"TrustId",null,"SubmissionId",null,"MetaSubmissionId",null,"Research Ethics Committee Reference Number",null,"Integrated Research Application System Number",null,"Name of Trial",null,"Target Number Of Patients Agreed?",null,"Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)",null,"Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)",null,"Target Date To Recruit Patients Agreed?",null,"Date Agreed to recruit target number of patients",null,"Total Number Of Patients Recruited At The Agreed Target Date",null,"Date That The Trial Closed To Recruitment",null,"Reason For Closure Of Trial",null,"Comments",null,"AddedByUserId",null,"AmendedByUserId",null,"DateAdded",null,"DateAmended"]
["Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2501,"Not Available / Not Agreed",null,null,null,null,2601,"Not Available / Not Agreed",null,null,null,null,null,null,2701,"Recruitment Finished",null,null,329,"Unknown",329,"Unknown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2502,"Number Agreed",null,null,null,null,2602,"Date Agreed",null,null,null,null,null,null,2702,"Withdrawn By Sponsor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2503,"Range Agreed",null,null,null,null,-99999911,"Unknown",null,null,null,null,null,null,2703,"Withdrawn By Host"]

{"sheet":"Help","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null," Spreadsheet Help"]