{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Disclaimer","Instructions","Input","Collections","Patients","Races","Accrual Count","Export","Definitions"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Instructions","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[0,1,0,4],[8,1,8,4],[11,1,11,4],[14,1,14,4]]}
[null,"CTRP Accruals Spreadsheet"]
[]
[null,"Revision","Purpose","Date","Author"]
[null,"1.0","Initial draft","2012-09-23","Patrick McConnell"]
[null,"1.1","Changed language","2012-10-10","Patrick McConnell"]
[null,"1.2","Changed language","2012-10-17","Patrick McConnell"]
[]
[null,"Purpose"]
[null,"The purpose of this Workbook is to provide an mechanism to capture accruals data to be imported into the CTRP accruals application using the Batch Import functionality.  This is an alternative to entering data directly into the CTRP Accruals application using the website, generating a batch upload file directly, or using the CTRP accruals APIs.  The ultimate goal of using this Workbook is to export data for import into CTRP Accruals using the Batch Import function on the CTRP Accruals website.  Use of that website is outside the scope of these instructions"]
[]
[null,"Entering Data"]
[null,"Data can be entered either through the Input Worksheet or directly into the Collections, Patients, Races, and Accrual Count Worksheets.  The Input Worksheet requires that you first enter study details into the first section and then click either the Complete Trials button or Abbreviated Trials button to view the rest of the fields that are available.  Then, click the Add Subject or Add Accrual button respectively.  If the data is valid and entered correctly, it will be moved into the correct worksheet.  If you enter data into the Collections, Patients, Races, and Accrual Count Worksheets manually, you must insure that identifiers are correctly maintained across the spreadsheets and that the data is appropriately formatted.  You can click the field names on the Input Worksheet to view the definition of the field."]
[]
[null,"Exporting Data"]
[null,"Data is exported to a CSV file by navigating to the Export Worksheet and clicking the Export button.  You will be prompted for a file name, and any existing file will be overwritten.  You can only export data for Complete Trials and Abbreviated trials separately by clicking the appropriate Export button.  Clicking the Clear All Data button will erase data from the Collections, Patients, Races, and Accrual Count worksheets. "]

{"sheet":"Input","index":2,"n_rows":244,"n_cols":14,"rows_kept":244}
[]
[{"$nulls":3},"Study Details"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!A1)","v":"*Study Id"},null,{"$f":"Collections!B1","v":"Change Code"}]
[]
[]
[null,null,"Add Accrual",{"$nulls":5},{"$f":"E3","v":"Change Code"},{"$f":"C11","v":"*Country of Residence"},{"$f":"C13","v":"*Gender of a Person"},{"$f":"C14","v":"*Ethnicity"},{"$f":"C15","v":"Payment Method"},{"$f":"C20","v":"*Race"}]
[{"$nulls":8},1,"AF","Female","Hispanic or Latino","Managed Care","American Indian or Alaska Native"]
[{"$nulls":3},"Complete Trial Details",{"$nulls":4},0,"AL","Male","Not Hispanic or Latino","Medicare","Asian"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!B1)","v":"*Study Subject Identifier "},{"$nulls":6},"DZ","Unknown","Not Reported","Medicaid","White"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!C1)","v":"*Zip Code (if US)"},{"$nulls":6},"AS","Unspecified","Unknown","Medicaid and Medicare","Black or African American"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!D1)","v":"*Country of Residence"},{"$nulls":6},"AD",null,null,"Medicare and Private Insurance","Not Reported"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!E1)","v":"*Patient’s Date of Birth"},{"$nulls":6},"AO",null,null,"Military or Veterans Sponsored, NOS","Unknown"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!F1)","v":"*Gender of a Person"},{"$nulls":6},"AI",null,null,"Military Sponsored (Including CHAMPUS & TriCare)","Native Hawaiian or other Pacific Islander"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!G1)","v":"*Ethnicity"},{"$nulls":6},"AQ",null,null,"No Means of Payment (No Insurance)"]
[null,null,{"$f":"Patients!H1","v":"Payment Method"},{"$nulls":6},"AG",null,null,"Other"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!I1)","v":"*Subject Registration Date"},{"$nulls":6},"AR",null,null,"Private Insurance"]
[null,null,{"$f":"Patients!J1","v":"Registering Group Identifier"},{"$nulls":6},"AM",null,null,"Self-Pay (No Insurance)"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!K1)","v":"*Study Site Identifier"},{"$nulls":6},"AW",null,null,"State Supplemental Health Insurance"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!L1)","v":"*Subject Disease Code"},{"$nulls":6},"AU",null,null,"Unknown"]
[null,null,{"$f":"CONCATENATE(\"*\",Races!C1)","v":"*Race"},{"$nulls":6},"AT",null,null,"Veterans Sponsored"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"AZ"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"BS"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"BH"]
[{"$nulls":9},"BD"]
[{"$nulls":9},"BB"]
[{"$nulls":3},"Abbreviated Trial Details",{"$nulls":5},"BY"]
[null,null,{"$f":"CONCATENATE(\"*\",'Accrual Count'!B1)","v":"*Study Site Accrual Count"},{"$nulls":6},"BE"]
[null,null,{"$f":"CONCATENATE(\"*\",'Accrual Count'!C1)","v":"*Study Site Identifier"},{"$nulls":6},"BZ"]
[{"$nulls":9},"BJ"]
[{"$nulls":9},"BM"]
[{"$nulls":9},"BT"]
[{"$nulls":9},"BO"]
[{"$nulls":4},"Add Accrual",{"$nulls":4},"BA"]
[{"$nulls":9},"BW"]
[{"$nulls":9},"BV"]
[{"$nulls":9},"BR"]
[{"$nulls":9},"IO"]
[{"$nulls":9},"BN"]
[{"$nulls":9},"BG"]
[{"$nulls":9},"BF"]
[{"$nulls":9},"BI"]
[{"$nulls":9},"KH"]
[{"$nulls":9},"CM"]
[{"$nulls":9},"CA"]
[{"$nulls":9},"CV"]
[{"$nulls":9},"KY"]
[{"$nulls":9},"CF"]
[{"$nulls":9},"TD"]
[{"$nulls":9},"CL"]
[{"$nulls":9},"CN"]
[{"$nulls":9},"CX"]
[{"$nulls":9},"CC"]
[{"$nulls":9},"CO"]
[{"$nulls":9},"KM"]
[{"$nulls":9},"CG"]
[{"$nulls":9},"CD"]
[{"$nulls":9},"CK"]
[{"$nulls":9},"CR"]
[{"$nulls":9},"CI"]
[{"$nulls":9},"HR"]
[{"$nulls":9},"CU"]
[{"$nulls":9},"CY"]
[{"$nulls":9},"CZ"]
[{"$nulls":9},"DK"]
[{"$nulls":9},"DJ"]
[{"$nulls":9},"DM"]
[{"$nulls":9},"DO"]
[{"$nulls":9},"TP"]
[{"$nulls":9},"EC"]
[{"$nulls":9},"EG"]
[{"$nulls":9},"SV"]
[{"$nulls":9},"GQ"]
[{"$nulls":9},"ER"]
[{"$nulls":9},"EE"]
[{"$nulls":9},"ET"]
[{"$nulls":9},"FK"]
[{"$nulls":9},"FO"]
[{"$nulls":9},"FJ"]
[{"$nulls":9},"FI"]
[{"$nulls":9},"FR"]
[{"$nulls":9},"FX"]
[{"$nulls":9},"GF"]
[{"$nulls":9},"PF"]
[{"$nulls":9},"TF"]
[{"$nulls":9},"GA"]
[{"$nulls":9},"GM"]
[{"$nulls":9},"GE"]
[{"$nulls":9},"DE"]
[{"$nulls":9},"GH"]
[{"$nulls":9},"GI"]
[{"$nulls":9},"GR"]
[{"$nulls":9},"GL"]
[{"$nulls":9},"GD"]
[{"$nulls":9},"GP"]
[{"$nulls":9},"GU"]
[{"$nulls":9},"GT"]
[{"$nulls":9},"GN"]
[{"$nulls":9},"GW"]
[{"$nulls":9},"GY"]
[{"$nulls":9},"HT"]
[{"$nulls":9},"HM"]
[{"$nulls":9},"VA"]
[{"$nulls":9},"HN"]
[{"$nulls":9},"HK"]
[{"$nulls":9},"HU"]
[{"$nulls":9},"IS"]
[{"$nulls":9},"IN"]
[{"$nulls":9},"ID"]
[{"$nulls":9},"IR"]
[{"$nulls":9},"IQ"]
[{"$nulls":9},"IE"]
[{"$nulls":9},"IL"]
[{"$nulls":9},"IT"]
[{"$nulls":9},"JM"]
[{"$nulls":9},"JP"]
[{"$nulls":9},"JO"]
[{"$nulls":9},"KZ"]
[{"$nulls":9},"KE"]
[{"$nulls":9},"KI"]
[{"$nulls":9},"KP"]
[{"$nulls":9},"KR"]
[{"$nulls":9},"KW"]
[{"$nulls":9},"KG"]
[{"$nulls":9},"LA"]
[{"$nulls":9},"LV"]
[{"$nulls":9},"LB"]
[{"$nulls":9},"LS"]
[{"$nulls":9},"LR"]
[{"$nulls":9},"LY"]
[{"$nulls":9},"LI"]
[{"$nulls":9},"LT"]
[{"$nulls":9},"LU"]
[{"$nulls":9},"MO"]
[{"$nulls":9},"MK"]
[{"$nulls":9},"MG"]
[{"$nulls":9},"MW"]
[{"$nulls":9},"MY"]
[{"$nulls":9},"MV"]
[{"$nulls":9},"ML"]
[{"$nulls":9},"MT"]
[{"$nulls":9},"MH"]
[{"$nulls":9},"MQ"]
[{"$nulls":9},"MR"]
[{"$nulls":9},"MU"]
[{"$nulls":9},"YT"]
[{"$nulls":9},"MX"]
[{"$nulls":9},"FM"]
[{"$nulls":9},"MD"]
[{"$nulls":9},"MC"]
[{"$nulls":9},"MN"]
[{"$nulls":9},"MS"]
[{"$nulls":9},"MA"]
[{"$nulls":9},"MZ"]
[{"$nulls":9},"MM"]
[{"$nulls":9},"NA"]
[{"$nulls":9},"NR"]
[{"$nulls":9},"NP"]
[{"$nulls":9},"NL"]
[{"$nulls":9},"AN"]
[{"$nulls":9},"NC"]
[{"$nulls":9},"NZ"]
[{"$nulls":9},"NI"]
[{"$nulls":9},"NE"]
[{"$nulls":9},"NG"]
[{"$nulls":9},"NU"]
[{"$nulls":9},"NF"]
[{"$nulls":9},"MP"]
[{"$nulls":9},"NO"]
[{"$nulls":9},"OM"]
[{"$nulls":9},"PK"]
[{"$nulls":9},"PW"]
[{"$nulls":9},"PA"]
[{"$nulls":9},"PG"]
[{"$nulls":9},"PY"]
[{"$nulls":9},"PE"]
[{"$nulls":9},"PH"]
[{"$nulls":9},"PN"]
[{"$nulls":9},"PL"]
[{"$nulls":9},"PT"]
[{"$nulls":9},"PR"]
[{"$nulls":9},"QA"]
[{"$nulls":9},"RE"]
[{"$nulls":9},"RO"]
[{"$nulls":9},"RU"]
[{"$nulls":9},"RW"]
[{"$nulls":9},"KN"]
[{"$nulls":9},"LC"]
[{"$nulls":9},"VC"]
[{"$nulls":9},"WS"]
[{"$nulls":9},"SM"]
[{"$nulls":9},"ST"]
[{"$nulls":9},"SA"]
[{"$nulls":9},"SN"]
[{"$nulls":9},"SC"]
[{"$nulls":9},"SL"]
[{"$nulls":9},"SG"]
[{"$nulls":9},"SK"]
[{"$nulls":9},"SI"]
[{"$nulls":9},"SB"]
[{"$nulls":9},"SO"]
[{"$nulls":9},"ZA"]
[{"$nulls":9},"GS"]
[{"$nulls":9},"ES"]
[{"$nulls":9},"LK"]
[{"$nulls":9},"SH"]
[{"$nulls":9},"PM"]
[{"$nulls":9},"SD"]
[{"$nulls":9},"SR"]
[{"$nulls":9},"SJ"]
[{"$nulls":9},"SZ"]
[{"$nulls":9},"SE"]
[{"$nulls":9},"CH"]
[{"$nulls":9},"SY"]
[{"$nulls":9},"TW"]
[{"$nulls":9},"TJ"]
[{"$nulls":9},"TZ"]
[{"$nulls":9},"TH"]
[{"$nulls":9},"TG"]
[{"$nulls":9},"TK"]
[{"$nulls":9},"TO"]
[{"$nulls":9},"TT"]
[{"$nulls":9},"TN"]
[{"$nulls":9},"TR"]
[{"$nulls":9},"TM"]
[{"$nulls":9},"TC"]
[{"$nulls":9},"TV"]
[{"$nulls":9},"UG"]
[{"$nulls":9},"UA"]
[{"$nulls":9},"AE"]
[{"$nulls":9},"GB"]
[{"$nulls":9},"US"]
[{"$nulls":9},"UM"]
[{"$nulls":9},"UY"]
[{"$nulls":9},"UZ"]
[{"$nulls":9},"VU"]
[{"$nulls":9},"VE"]
[{"$nulls":9},"VN"]
[{"$nulls":9},"VG"]
[{"$nulls":9},"VI"]
[{"$nulls":9},"WF"]
[{"$nulls":9},"EH"]
[{"$nulls":9},"YE"]
[{"$nulls":9},"ZM"]
[{"$nulls":9},"ZW"]

{"sheet":"Collections","index":3,"n_rows":1,"n_cols":2,"rows_kept":1}
["Study Id","Change Code"]

{"sheet":"Patients","index":4,"n_rows":1,"n_cols":12,"rows_kept":1}
["Study Id","Study Subject Identifier ","Zip Code (if US)","Country of Residence","Patient’s Date of Birth","Gender of a Person","Ethnicity","Payment Method","Subject Registration Date","Registering Group Identifier","Study Site Identifier","Subject Disease Code"]

{"sheet":"Races","index":5,"n_rows":1,"n_cols":3,"rows_kept":1}
["Study Id","Study Subject Identifier ","Race"]

{"sheet":"Accrual Count","index":6,"n_rows":1,"n_cols":3,"rows_kept":1}
["Study Id","Study Site Accrual Count","Study Site Identifier"]

{"sheet":"Export","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Definitions","index":8,"n_rows":16,"n_cols":2,"rows_kept":16}
["Data Element","Definition"]
[{"$f":"Input!C3","v":"*Study Id"},"This is the unique identifier assigned to the study."]
[{"$f":"Input!E3","v":"Change Code"},"Whether the data has not changed since the last report"]
[{"$f":"Input!C9","v":"*Study Subject Identifier "},"Unique identifier (PO ID) assigned to the institution accruing the patient to the study."]
[{"$f":"Input!C10","v":"*Zip Code (if US)"},"The string of characters used to identify the five-digit Zone Improvement Plan (ZIP) code that represents the geographic segment that is a subunit of the ZIPcode, assigned by the U.S. Postal Service to a geographic location to facilitate mail delivery."]
[{"$f":"Input!C11","v":"*Country of Residence"},"The name of a country from which a person or their biological family had previous residence or past ancestors. Condition: either Zip code (if U.S resident) or country (if not U.S resident) is mandatory."]
[{"$f":"Input!C12","v":"*Patient’s Date of Birth"},"The month and year on which the person was born"]
[{"$f":"Input!C13","v":"*Gender of a Person"},"Text designations that identify gender. Gender is described as the assemblage of properties that distinguish people on the basis of their societal roles."]
[{"$f":"Input!C14","v":"*Ethnicity"},"The text for reporting information about ethnicity based on the Office of Management and Budget (OMB) categories."]
[{"$f":"Input!C15","v":"Payment Method"},"Text term for an entity, organization, government, corporation, health plan sponsor, or any other financial agent who pays a healthcare provider for the healthcare service rendered to a person or reimburses the cost of the healthcare service.<y."]
[{"$f":"Input!C16","v":"*Subject Registration Date"},"Date the subject was registered for the study.<y."]
[{"$f":"Input!C17","v":"Registering Group Identifier"},"Unique identifier (PO ID) assigned to the group that originally registered the patient for the study"]
[{"$f":"Input!C18","v":"*Study Site Identifier"},"Unique identifier (numeric or alphanumeric) assigned to the study site"]
[{"$f":"Input!C19","v":"*Subject Disease Code"},"Code that identifies a disease.< study.<y."]
[{"$f":"Input!C20","v":"*Race"},"The text for reporting information about race based on the Office of Management and Budget (OMB) categories.<y."]
[{"$f":"Input!C27","v":"*Study Site Accrual Count"},"Numeric count of subjects accrued at a study site to date"]